package user.model;

import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import db.dto.BookVo;
import db.dto.IsbnSaveDto;
import db.dto.SheetDto;

public interface Shop {
  public void insertExcel(String xslPath);
  public String getBooks(String num);
  public void update(String b_jemok, String num, String snum, String tablename);
  public void nameupdate(String b_name, String num, String snum, String tablename);
  public void companyupdate(String b_company, String num, String snum, String tablename);
  public void isbnupdate(String b_isbn, String num, String snum, String tablename);
  //public ArrayList<SheetDto> getSheetNumAndNames(String xslPath);
  public String getSheetNumAndNames(String xslPath);
  public String getSheetList(String tableName);
  public String getFileName(String snum);
  public void isbnSave(String snum,IsbnSaveDto dto);
  public void excelSave(String snum,String sname, String excelPath, String tablename) throws IOException;
  public void alldelete(String excelPath, String tablename);
  public boolean isLogin(String id, String pwd);
}
